package com.icss.dao;

import com.icss.pojo.CityPojo;
import com.icss.pojo.CountryPojo;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

@Mapper
public interface CityMapper {

    @Select("" +
            "SELECT c.city_id,\n" +
            "       c.city,\n" +
            "       c.country_id,\n" +
            "       c.last_update\n" +
            "FROM city c")
    List<CityPojo> findAllData();

    List<CityPojo> findByCity(String city);
    List<CityPojo> findByCity0(CityPojo pojo);
    List<CityPojo> findByCity1(CityPojo pojo);

    List<CountryPojo> findByCity2(CityPojo pojo);

}
